home *** CD-ROM | disk | FTP | other *** search
/ The 640 MEG Shareware Studio 2 / The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO / ss / actrec.zip / ACTREC.CAL (.txt) next >
SuperCalc Worksheet  |  1986-10-09  |  4KB  |  123 lines
  1. SuperCalc ver.  1.00
  2. ACTRECA5 - ACT REC DSK #5 PART A
  3. "ACTRECA5 - ACT REC DSK #5 PART A
  4. "<---|
  5. A5 - AC
  6. "End of the month: --
  7. "Page 1 of 1
  8. " INVOICE#
  9. " BJ-AMT
  10. "   MISC
  11. "  TOTAL
  12. "<---|
  13. "        Totals of column 'E', 'F' and 'G'
  14. (J8>0,(
  15. "DATE->
  16. DATE(10,06,83)
  17. B8)<1
  18. "  Y=("Y")
  19. "  -400
  20. "  -405
  21. "  +110
  22. "Consolidated-|
  23. 0,06,8
  24. "        Arrange printout by column 'H'
  25. 10,06,8
  26. 10,06,8
  27. "TOTAL OUTSTANDING (Late Charges NOT Included)
  28. SUM(E7:E50)+SUM(F7:F50)-SUM(J7:J50)+I1
  29. -----
  30. "   --RECEIPTS--
  31. " ||-------- PAST DUE SUMMARY --------||
  32. 7:E50)+
  33. "TOTAL BILLED-CURRENT MONTH (JE not Included)
  34. SUM(G9:G50)+I2
  35. (F7:F
  36. "   DATE   AMOUNT
  37. "  30
  38. "  60
  39. "  90
  40. "  120
  41. E   AMO
  42. "  150
  43. E   AMO
  44. "   POSTED
  45. "DAYS
  46. 9:G50)+
  47. 9:G50)+
  48. IF(AND(G8-J8=0,C8="Y"),999999999,0)
  49. -----
  50. DATE(6,16,83)
  51. ,C8="Y
  52. ("Y")
  53. ,16,83
  54. "8910K
  55. 78.21
  56. E8+F8
  57. ,16,83
  58. IF(OR(J8>0,(B3-B8)<30),0,99999)
  59. IF(OR(J8>0,(B3-B8)<60),0,99999)
  60. IF(OR(J8>0,(B3-B8)<90),0,99999)
  61. IF(OR(J8>0,(B3-B8)<120),0,99999)
  62. IF(OR(J8>0,(B3-B8)<150),0,99999)
  63. IF((R8-P8)>29,999999,0)
  64. IF(J8=0,B3-B8,0)
  65. =0,B3-B
  66. IF(AND(G9-J9=0,C9="Y"),999999999,0)
  67. -----
  68. DATE(9,3,83)
  69. 0,C9="Y
  70. ("Y")
  71. ,3,83)
  72. "5358A
  73. 963.76
  74. E9+F9
  75. ,3,83)
  76. DATE(10,22,83)
  77. C9="Y    
  78. 963.76
  79. IF(OR(J9>0,(B3-B9)<30),0,99999)
  80. IF(OR(J9>0,(B3-B9)<60),0,99999)
  81. IF(OR(J9>0,(B3-B9)<90),0,99999)
  82. IF(OR(J9>0,(B3-B9)<120),0,99999)
  83. IF(OR(J9>0,(B3-B9)<150),0,99999)
  84. IF((R9-P9)>29,999999,0)
  85. IF(J9=0,B3-B9,0)
  86. =0,B3-B
  87. IF(AND(G10-J10=0,C10="Y"),999999999,0)
  88. -----
  89. DATE(9,5,83)
  90. 0=0,C10
  91. ("Y")
  92. ,5,83)
  93. "1683C
  94. 2171.43
  95. E10+F10
  96. IF(OR(J10>0,(B3-B10)<30),0,99999)
  97. IF(OR(J10>0,(B3-B10)<60),0,99999)
  98. IF(OR(J10>0,(B3-B10)<90),0,99999)
  99. IF(OR(J10>0,(B3-B10)<120),0,99999)
  100. IF(OR(J10>0,(B3-B10)<150),0,99999)
  101. IF((R10-P10)>29,999999,0)
  102. IF(J10=0,B3-B10,0)
  103. 0=0,B3-
  104. IF(AND(G11-J11=0,C11="Y"),999999999,0)
  105. -----
  106. DATE(9,9,83)
  107. 1=0,C11
  108. ("Y")
  109. ,9,83)
  110. "4198A
  111. E11+F11
  112. DATE(9,23,83)
  113. =0,C11    
  114. IF(OR(J11>0,(B3-B11)<30),0,99999)
  115. IF(OR(J11>0,(B3-B11)<60),0,99999)
  116. IF(OR(J11>0,(B3-B11)<90),0,99999)
  117. IF(OR(J11>0,(B3-B11)<120),0,99999)
  118. IF(OR(J11>0,(B3-B11)<150),0,99999)
  119. IF((R11-P11)>29,999999,0)
  120. IF(J11=0,B3-B11,0)
  121. T10+1
  122. =0,B3-
  123.